<?xml version="1.0" encoding="UTF-8"?>
<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.1" Build="10.50.1600.1">
   <BatchSequence>
      <Batch>
         <Statements>
            <StmtSimple StatementText="SELECT TOP 1 Posts.Id FROM Posts&#xA;WHERE Posts.Id In&#xA;(&#xA;    SELECT Id FROM Posts&#xA;    WHERE Tags IN&#xA;    (&#xA;        SELECT TagName FROM Tags&#xA;        WHERE Id IN&#xA;        (&#xA;            SELECT Id FROM Votes&#xA;        )&#xA;    )&#xA;)" StatementId="1" StatementCompId="1" StatementType="SELECT" StatementSubTreeCost="0.0131454" StatementEstRows="1" StatementOptmLevel="FULL" QueryHash="0x575FBF2D7F38CF78" QueryPlanHash="0x09E8734F4431FA1E" StatementOptmEarlyAbortReason="GoodEnoughPlanFound">
               <StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false" />
               <QueryPlan DegreeOfParallelism="0" CachedPlanSize="24" CompileTime="24" CompileCPU="24" CompileMemory="456">
                  <RelOp NodeId="0" PhysicalOp="Top" LogicalOp="Top" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0131454" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                     <OutputList>
                        <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[Posts]" Column="Id" />
                     </OutputList>
                     <RunTimeInformation>
                        <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
                     </RunTimeInformation>
                     <Top RowCount="0" IsPercent="0" WithTies="0">
                        <TopExpression>
                           <ScalarOperator ScalarString="(1)">
                              <Const ConstValue="(1)" />
                           </ScalarOperator>
                        </TopExpression>
                        <RelOp NodeId="1" PhysicalOp="Nested Loops" LogicalOp="Left Semi Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0131453" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                           <OutputList>
                              <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[Posts]" Column="Id" />
                           </OutputList>
                           <RunTimeInformation>
                              <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
                           </RunTimeInformation>
                           <NestedLoops Optimized="0">
                              <OuterReferences>
                                 <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[Posts]" Column="Id" />
                              </OuterReferences>
                              <RelOp NodeId="2" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                                 <OutputList>
                                    <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[Posts]" Column="Id" />
                                 </OutputList>
                                 <RunTimeInformation>
                                    <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
                                 </RunTimeInformation>
                                 <IndexScan Ordered="0" ForcedIndex="0" NoExpandHint="0">
                                    <DefinedValues>
                                       <DefinedValue>
                                          <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[Posts]" Column="Id" />
                                       </DefinedValue>
                                    </DefinedValues>
                                    <Object Database="[StackOverflow]" Schema="[dbo]" Table="[Posts]" Index="[PK_Posts]" TableReferenceId="1" IndexKind="Clustered" />
                                 </IndexScan>
                              </RelOp>
                              <RelOp NodeId="3" PhysicalOp="Nested Loops" LogicalOp="Left Semi Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="9" EstimatedTotalSubtreeCost="0.00985806" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                                 <OutputList />
                                 <RunTimeInformation>
                                    <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                 </RunTimeInformation>
                                 <NestedLoops Optimized="0">
                                    <Predicate>
                                       <ScalarOperator ScalarString="[StackOverflow].[dbo].[Posts].[Tags]=[Expr1013]">
                                          <Compare CompareOp="EQ">
                                             <ScalarOperator>
                                                <Identifier>
                                                   <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[Posts]" Column="Tags" />
                                                </Identifier>
                                             </ScalarOperator>
                                             <ScalarOperator>
                                                <Identifier>
                                                   <ColumnReference Column="Expr1013" />
                                                </Identifier>
                                             </ScalarOperator>
                                          </Compare>
                                       </ScalarOperator>
                                    </Predicate>
                                    <RelOp NodeId="4" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="12" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                                       <OutputList>
                                          <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[Posts]" Column="Tags" />
                                       </OutputList>
                                       <RunTimeInformation>
                                          <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                       </RunTimeInformation>
                                       <IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" NoExpandHint="0">
                                          <DefinedValues>
                                             <DefinedValue>
                                                <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[Posts]" Column="Tags" />
                                             </DefinedValue>
                                          </DefinedValues>
                                          <Object Database="[StackOverflow]" Schema="[dbo]" Table="[Posts]" Index="[PK_Posts]" TableReferenceId="2" IndexKind="Clustered" />
                                          <SeekPredicates>
                                             <SeekPredicateNew>
                                                <SeekKeys>
                                                   <Prefix ScanType="EQ">
                                                      <RangeColumns>
                                                         <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[Posts]" Column="Id" />
                                                      </RangeColumns>
                                                      <RangeExpressions>
                                                         <ScalarOperator ScalarString="[StackOverflow].[dbo].[Posts].[Id]">
                                                            <Identifier>
                                                               <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[Posts]" Column="Id" />
                                                            </Identifier>
                                                         </ScalarOperator>
                                                      </RangeExpressions>
                                                   </Prefix>
                                                </SeekKeys>
                                             </SeekPredicateNew>
                                          </SeekPredicates>
                                       </IndexScan>
                                    </RelOp>
                                    <RelOp NodeId="6" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="12" EstimatedTotalSubtreeCost="0.00657048" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                                       <OutputList>
                                          <ColumnReference Column="Expr1013" />
                                       </OutputList>
                                       <RunTimeInformation>
                                          <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                       </RunTimeInformation>
                                       <NestedLoops Optimized="0">
                                          <OuterReferences>
                                             <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[Tags]" Column="Id" />
                                          </OuterReferences>
                                          <RelOp NodeId="7" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="16" EstimatedTotalSubtreeCost="0.0032832" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                                             <OutputList>
                                                <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[Tags]" Column="Id" />
                                                <ColumnReference Column="Expr1013" />
                                             </OutputList>
                                             <ComputeScalar>
                                                <DefinedValues>
                                                   <DefinedValue>
                                                      <ColumnReference Column="Expr1013" />
                                                      <ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(255),[StackOverflow].[dbo].[Tags].[TagName],0)">
                                                         <Convert DataType="nvarchar" Length="510" Style="0" Implicit="1">
                                                            <ScalarOperator>
                                                               <Identifier>
                                                                  <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[Tags]" Column="TagName" />
                                                               </Identifier>
                                                            </ScalarOperator>
                                                         </Convert>
                                                      </ScalarOperator>
                                                   </DefinedValue>
                                                </DefinedValues>
                                                <RelOp NodeId="8" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="16" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                                                   <OutputList>
                                                      <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[Tags]" Column="Id" />
                                                      <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[Tags]" Column="TagName" />
                                                   </OutputList>
                                                   <RunTimeInformation>
                                                      <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                                   </RunTimeInformation>
                                                   <IndexScan Ordered="0" ForcedIndex="0" NoExpandHint="0">
                                                      <DefinedValues>
                                                         <DefinedValue>
                                                            <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[Tags]" Column="Id" />
                                                         </DefinedValue>
                                                         <DefinedValue>
                                                            <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[Tags]" Column="TagName" />
                                                         </DefinedValue>
                                                      </DefinedValues>
                                                      <Object Database="[StackOverflow]" Schema="[dbo]" Table="[Tags]" Index="[PK__Tags__3214EC076383C8BA]" IndexKind="Clustered" />
                                                   </IndexScan>
                                                </RelOp>
                                             </ComputeScalar>
                                          </RelOp>
                                          <RelOp NodeId="12" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                                             <OutputList />
                                             <RunTimeInformation>
                                                <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                             </RunTimeInformation>
                                             <IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" NoExpandHint="0">
                                                <DefinedValues />
                                                <Object Database="[StackOverflow]" Schema="[dbo]" Table="[Votes]" Index="[PK_Votes]" IndexKind="Clustered" />
                                                <SeekPredicates>
                                                   <SeekPredicateNew>
                                                      <SeekKeys>
                                                         <Prefix ScanType="EQ">
                                                            <RangeColumns>
                                                               <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[Votes]" Column="Id" />
                                                            </RangeColumns>
                                                            <RangeExpressions>
                                                               <ScalarOperator ScalarString="[StackOverflow].[dbo].[Tags].[Id]">
                                                                  <Identifier>
                                                                     <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[Tags]" Column="Id" />
                                                                  </Identifier>
                                                               </ScalarOperator>
                                                            </RangeExpressions>
                                                         </Prefix>
                                                      </SeekKeys>
                                                   </SeekPredicateNew>
                                                </SeekPredicates>
                                             </IndexScan>
                                          </RelOp>
                                       </NestedLoops>
                                    </RelOp>
                                 </NestedLoops>
                              </RelOp>
                           </NestedLoops>
                        </RelOp>
                     </Top>
                  </RelOp>
               </QueryPlan>
            </StmtSimple>
         </Statements>
      </Batch>
   </BatchSequence>
</ShowPlanXML>